package prueba.constans;

import java.io.Serializable;




public class PgQuerys implements Serializable{
	
	private static final long serialVersionUID = 1L;
	
	public static final String 
	INSERTAR_ALMACEN ="INSERT INTO tb_articulo (cod_articulo,nom_articulo,cant_articulo) VALUES (:cod_articulo,:nom_articulo,:cant_articulo)",
	
	LISTAR_ALMACEN ="SELECT id_articulo,cod_articulo,nom_articulo,cant_articulo FROM tb_articulo WHERE 1=1",	
	
	ELIMINAR_ALMACEN="DELETE FROM tb_articulo where id_articulo= :id_articulo  ",
    
	OBTENER_POR_ID="SELECT id_articulo,cod_articulo,nom_articulo,cant_articulo FROM tb_articulo WHERE 1=1 ",
    
	MODIFICAR_ALMACEN="UPDATE tb_articulo SET cod_articulo=:cod_articulo, nom_articulo=:nom_articulo,cant_articulo =:cant_articulo where id_articulo=:id_articulo ",
    
	CANTIDAD_REGISTROS_ALMACEN="SELECT count(id_articulo) FROM tb_articulo where 1= 1 ";
}
